| FaSscr001 |
| Logical Entity Name | FaSscr001 |
| Default Table Name | FaSscr001 |
| Physical Only | NO |
| Definition | |
| Note |
| FaSscr001 Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
FaSscr001Id |
char(10) | NO | ||
| SSN | char(10) | YES | ||
| SchoolCode | char(10) | YES | ||
| SchoolBranchCode | char(10) | YES | ||
| MoveToSchoolBranchCode | char(10) | YES | ||
| SSNIndicator | char(10) | YES | ||
| FirstName | char(10) | YES | ||
| LastName | char(10) | YES | ||
| MiddleName | char(10) | YES | ||
| DOB | char(10) | YES | ||
| BranchDesignatorCode | char(10) | YES | ||
| CertificationDate | char(10) | YES | ||
| EnrollmentEffectiveDate | char(10) | YES | ||
| EnrollmentStatus | char(10) | YES | ||
| AnticipatedCompletionDate | char(10) | YES | ||
| TermBeginDate | char(10) | YES | ||
| TermEndDate | char(10) | YES | ||
| AddressEffectiveDate | char(10) | YES | ||
| GoodAddressFlag | char(10) | YES | ||
| StreetAddr1 | char(10) | YES | ||
| StreetAddr2 | char(10) | YES | ||
| City | char(10) | YES | ||
| State | char(10) | YES | ||
| Country | char(10) | YES | ||
| PostalCode | char(10) | YES | ||
| PhoneType | char(10) | YES | ||
| PhoneNumberFlag | char(10) | YES | ||
| PhoneCountryCode | char(10) | YES | ||
| PhoneNumber | char(10) | YES | ||
| OldLastName | char(10) | YES | ||
| OldFirstName | char(10) | YES | ||
| OldMiddleName | char(10) | YES | ||
| OldDOB | char(10) | YES | ||
| OldEnrollmentStatus | char(10) | YES | ||
| OldAnticipatedCompletionDate | char(10) | YES | ||
| OldEnrollmentEffectiveDate | char(10) | YES | ||
| SyStudentId | char(10) | YES | ||
| SyCampusId | char(10) | YES | ||
| SySchoolStatusId | char(10) | YES | ||
| AdEnrollId | char(10) | YES | ||
| AttStatID | char(10) | YES | ||
| AdTermID | char(10) | YES | ||
| ClockCredit | char(10) | YES | ||
| TermCreditsSched | char(10) | YES | ||
| TermHoursSched | char(10) | YES | ||
| BatchId | char(10) | YES | ||
| ProgramIndicator | char(10) | YES | ||
| IsAddedToFile | char(10) | YES | ||
UserId |
int | NO | ||
| DateAdded | char(10) | NO | ||
| DateLstMod | char(10) | NO | ||
| Ts | char(10) | NO | ||
| TermCode | char(10) | YES | ||
| OPEID | char(10) | YES | ||
FaBatchExpImpId |
int | YES |
| FaSscr001 Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PK_FaSscr001_FaSscr001Id | PrimaryKey | FaSscr001Id |
| FaSscr001 Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| FaBatchExpImp | Non-Identifying | Zero or One to Zero or More | FK_FaSSCR001_FaBatchExpImpId_FaBatchExpImp_FaBatchExpImpId | FaBatchExpImpId | NO | YES | ||
| SyStaff | Non-Identifying | One To Zero or More | FK_FaSscr001UserId_SyStaffSyStaffId | UserId | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| FaSscr002 | Non-Identifying | One To Zero or More | FK_FaSscr002FaSscr001Id_FaSscr001FaSscr001Id | NO | YES | |||
| FaSscr003 | Non-Identifying | One To Zero or More | FK_FaSscr003FaSscr001Id_FaSscr001FaSscr001Id | NO | YES |
| FaSscr001 Check Constraints |
| Check Constraint Name | CheckConstraint |